Retrieve Oracle version information

Course- Oracle/PLSQL >

This Oracle tutorial explains how to find the Oracle version information with syntax and examples.

Description

You can check the Oracle version by running a query from the command prompt. The version information is stored in a table called v$version. In this table you can find the version information for Oracle, PL/SQL, etc.

Syntax

The syntax to retrieve the Oracle version information is:

SELECT * FROM v$version;

OR ...

SELECT * FROM v$version
WHERE banner LIKE 'Oracle%';

Parameters or Arguments

There are no parameters or arguments.

Example

Let's look at some of examples of how to retrieve version information from Oracle.

All Version Information

To retrieve all version information from Oracle, you could execute the following SQL statement:

SELECT * FROM v$version;

This query would output something like this:

Banner
--------------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE	11.2.0.2.0	Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

Oracle Version Only

If you only wanted the Oracle version information, you execute the following SQL statement:

SELECT * FROM v$version
WHERE banner LIKE 'Oracle%';

It should return something like this:

Banner
--------------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production